Limitations

When using the Amazon Target endpoint, the following limitation(s) apply:

The ALTER TABLE <NAME> MODIFY COLUMN <NAME> <DATA_TYPE> DDL is not supported.
The Allow unlimited LOB size option in the Target Metadata task settings is not supported.
If you need to replicate 4-byte emoji characters, use a transformation to convert the data type from WSTRING(n ) to WSTRING ( n*2 ).
If you need to replicate JSON values, Redshift is limited by the following:
- The duplicate attribute name cannot appear in the same object, but can appear in a nested object. By default, a data error is returned when a duplicate attribute is encountered in the same object. To choose how to handle duplicate attributes, see Setting advanced connection properties
- JSON data is stored using the SUPER data type. Each SUPER object can contain up to 65535 bytes of data. To choose how to handle objects exceeding this limit, see Setting advanced connection properties

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!